package com.mesmileAI.mapper;

import com.mesmileAI.entity.SmileText;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.mesmileAI.entity.SmileTransform;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author Administrator
* @description 针对表【smile_text】的数据库操作Mapper
* @createDate 2023-10-28 09:32:29
* @Entity autocode.entity.SmileText
*/
@Mapper
public interface SmileTextMapper extends BaseMapper<SmileText> {

    //返回值中没有text文章
    @Select("select id,name,index_id,level,hierarchy from `smile_text`")
    List<SmileTransform> listNotEdit();

    @Select("SELECT id,name,index_id,level,hierarchy FROM `smile_text` WHERE name LIKE #{name}")
    List<SmileText> getByName(@Param("name")String id);

}




